﻿--================================================================================================
--                                 Change History
--                                 --------------
-- Date          Who     Description
-- -----------   ------  --------------------------------------------------
-- 11/Oct/2024   AndyB   Added MARKBOOKMAINTLEVEL Items
-- 11/Oct/2024   AndyB   Added MARKBOOKMAINTFIELDNAMES Items
-- 16/Oct/2024   AndyB   Added MARKBOOKMAINTCATEGORIES Items
-- 16/Oct/2024   AndyB   Added MARKBOOKMAINTGRADECOLOURS Items
-- 16/Oct/2024   AndyB   Added MARKBOOKMAINTELEMENT items
-- 09/Feb/2025   AndyB   Added MARKBOOKSTATSSUMMARY items
-- 13/Feb/2025   AndyB   Added ENROLMENTELEMENTSTUDENTS items
-- 25/Apr/2025   AndyB   Added MARKBOOKSTUDENT items
--
--------------------------------------------------------------------------------------------------
--select distinct GridName from WebPlusTableColumn
--select * from WebPlusTableColumn
--------------------------------------------------------------------------------------------------

--Columns that had their names changed mid dev so ensure deleted and add again below
--DELETE FROM WebPlusTableColumn WHERE GridName = '???' 



--Markbook Maint Field Names Grid
--DELETE FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'Category')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'Category', 'Category', '', 'OGP_MarkbookField.OGP_MarkbookField_CategoryID --> OGP_MarkbookField_Category  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'SystemName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'SystemName', 'System Name', '', 'OGP_MarkbookField.SystemName  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'OverrideName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'OverrideName', 'Override Name', 'Can be entered to Override the SystemName', 'OGP_MarkbookField.OverrideName  [sp_WebPlus_MarkBookMaint_Select]')
END
--Abbr
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'SystemAbbvn')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'SystemAbbvn', 'System<br>Abbr', 'System Abbreviation', 'OGP_MarkbookField.SystemAbbvn  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'OverrideAbbvn')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'OverrideAbbvn', 'Override<br>Abbr', 'Can be entered to Override the SystemAbbreviation', 'OGP_MarkbookField.OverrideAbbvn  [sp_WebPlus_MarkBookMaint_Select]')
END
--Unit
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'UnitIsUsed')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'UnitIsUsed', 'Is Used<br>([UNIT])', 'For [UNIT]: Is this field used?', 'OGP_ElementType_MarkbookField.IsUsed WHERE ElementTypeID=1  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'UnitIsVisibleByDefault')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'UnitIsVisibleByDefault', 'Is Visible<br>([UNIT])', 'For [UNIT]: Is this field Visible by Default (only If Used)?', 'OGP_ElementType_MarkbookField.IsVisibleByDefault WHERE ElementTypeID=1  [sp_WebPlus_MarkBookMaint_Select]')
END
--Assessment
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'AssessmentIsUsed')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'AssessmentIsUsed', 'Is Used<br>([ASSESSMENT])', 'For [ASSESSMENT]: Is this field used?', 'OGP_ElementType_MarkbookField.IsUsed WHERE ElementTypeID=2  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'AssessmentIsVisibleByDefault')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'AssessmentIsVisibleByDefault', 'Is Visible<br>([ASSESSMENT])', 'For [ASSESSMENT]: Is this field Visible by Default (only If Used)?', 'OGP_ElementType_MarkbookField.IsVisibleByDefault WHERE ElementTypeID=2  [sp_WebPlus_MarkBookMaint_Select]')
END
--Criteria
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'CriteriaIsUsed')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'CriteriaIsUsed', 'Is Used<br>([CRITERIA])', 'For [CRITERIA]: Is this field used?', 'OGP_ElementType_MarkbookField.IsUsed WHERE ElementTypeID=3  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'CriteriaIsVisibleByDefault')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'CriteriaIsVisibleByDefault', 'Is Visible<br>([CRITERIA])', 'For [CRITERIA]: Is this field Visible by Default (only If Used)?', 'OGP_ElementType_MarkbookField.IsVisibleByDefault WHERE ElementTypeID=3  [sp_WebPlus_MarkBookMaint_Select]')
END
--OrderBy
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTFIELDNAMES' AND ColumnName = 'OrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTFIELDNAMES', 'OrderBy', 'Order<br>', 'The Display Order', 'OGP_MarkbookField.OrderBy  [sp_WebPlus_MarkBookMaint_Select]')
END



--Markbook Maint Element Level Grid
--DELETE FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTLEVEL' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTLEVEL' AND ColumnName = 'ElementLevel')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTLEVEL', 'ElementLevel', 'Level Name', '', 'OGP_Element_Level.ElementLevel  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTLEVEL' AND ColumnName = 'ElementDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTLEVEL', 'ElementDescription', 'Description', '', 'OGP_Element_Level.ElementDescription  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTLEVEL' AND ColumnName = 'OrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTLEVEL', 'OrderBy', 'Order', '', 'OGP_Element_Level.OrderBy  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTLEVEL' AND ColumnName = 'InUse')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTLEVEL', 'InUse', 'In Use', '', 'True if referenced in OGP_Element or OGP_Course_Element_Grade  [sp_WebPlus_MarkBookMaint_Select]')
END


--Markbook Maint Category Grid
--DELETE FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTCATEGORIES' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTCATEGORIES' AND ColumnName = 'Category')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTCATEGORIES', 'Category', 'Category Name', '', 'OGP_MarkbookField_Category.Category  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTCATEGORIES' AND ColumnName = 'InUse')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTCATEGORIES', 'InUse', 'In Use', '', 'True if referenced in OGP_MarkbookField  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTCATEGORIES' AND ColumnName = 'OrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTCATEGORIES', 'OrderBy', 'Order', 'The Display Order', 'OGP_MarkbookField_Category.OrderBy  [sp_WebPlus_MarkBookMaint_Select]')
END


--Markbook Maint GradeColours Grid
--DELETE FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTGRADECOLOURS' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTGRADECOLOURS' AND ColumnName = 'Type')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTGRADECOLOURS', 'Type', 'Element Type', '', 'OGP_ElementType_Grade_Colour.OGP_ElementTypeID --> OGP_ElementType  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTGRADECOLOURS' AND ColumnName = 'Grade')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTGRADECOLOURS', 'Grade', 'Grade', '', 'OGP_ElementType_Grade_Colour.Grade  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTGRADECOLOURS' AND ColumnName = 'Description')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTGRADECOLOURS', 'Description', 'Description', '', 'OGP_ElementType_Grade_Colour.Description  [sp_WebPlus_MarkBookMaint_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTGRADECOLOURS' AND ColumnName = 'BackgroundColour')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTGRADECOLOURS', 'BackgroundColour', 'Background Colour', '', 'OGP_ElementType_Grade_Colour.BackgroundColour  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTGRADECOLOURS' AND ColumnName = 'FontColour')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTGRADECOLOURS', 'FontColour', 'Font Colour', '', 'OGP_ElementType_Grade_Colour.FontColour  [sp_WebPlus_MarkBookMaint_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTGRADECOLOURS' AND ColumnName = 'OrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTGRADECOLOURS', 'OrderBy', 'Order', '', 'OGP_ElementType_Grade_Colour.OrderBy  [sp_WebPlus_MarkBookMaint_Select]')
END



--Markbook Maint Element Grid
--DELETE FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' 

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'ElementTypeID')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'ElementTypeID', 'Element Type', '', 'OGP_Element.OGP_ElementTypeID --> OGP_ElementType.Description  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'ElementCode')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'ElementCode', 'Code', '', 'OGP_Element.ElementCode  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'Description')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'Description', 'Description', '', 'OGP_Element.Description  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'ReportToParents')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'ReportToParents', 'Rpt. P/G', 'Report to Parents/Guardians', 'OGP_Element.ReportToParents  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS)')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'ExternalCode')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'ExternalCode', 'Ext. Code', 'External Code', 'OGP_Element.ExternalUnitCode  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS)')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'OrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'OrderBy', 'Order', '', 'OGP_Element.OrderBy  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'IsActive')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'IsActive', 'Active', '', 'True WHEN OGP_Element.RecordStatus=Active  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'Size')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'Size', 'Size', 'This is used to record the Size of a [UNIT] (usually its GLH or credit value)', 'OGP_Element.Size  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'OutOfPoints')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'OutOfPoints', 'Out of', 'This is used to record the maximum marks available for an [ASSESSMENT]', 'OGP_Element.OutOfPoints  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'ElementLevelID')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'ElementLevelID', 'NVQ Level', 'This is used to record the NVQ Level of a [UNIT]', 'OGP_Element.OGP_ElementLevelID --> OGP_Element_Level.ElementLevel  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'IsUsed')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'IsUsed', 'Used', 'Indicates the Element is Used in the Markbook', 'OGP_Element.ID Referenced BY (OGP_EnrolmentElement.OGP_ElementID)  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'IsAllocated')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'IsAllocated', 'Allocated', 'Indicates the Element is Allocated to at least one Group', 'OGP_Element.ID Referenced BY (OGP_GroupElement.OGP_ElementID)  [sp_WebPlus_MarkBookMaint_Select] (COURSEELEMENTS or CHILDELEMENTS)')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'DateSet')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'DateSet', 'Date Set', '', 'OGP_GroupElement.DateSet  [sp_WebPlus_MarkBookMaint_Select] (GROUPELEMENTS or CHILDGROUPELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'DateExpected')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'DateExpected', 'Date Expected', '', 'OGP_GroupElement.DateExpected  [sp_WebPlus_MarkBookMaint_Select] (GROUPELEMENTS or CHILDGROUPELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'StaffID')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'StaffID', 'Staff', '', 'OGP_GroupElement.StaffID --> Staff.StaffID  [sp_WebPlus_MarkBookMaint_Select] (GROUPELEMENTS or CHILDGROUPELEMENTS)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKMAINTELEMENT' AND ColumnName = 'DisplayInStudentView')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKMAINTELEMENT', 'DisplayInStudentView', 'Student View', 'Display in Student View', 'OGP_GroupElement.DisplayInStudentView  [sp_WebPlus_MarkBookMaint_Select] (GROUPELEMENTS or CHILDGROUPELEMENTS)')
END






--Markbook Stats Summary Grid
--DELETE FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' 
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'AcademicYearID')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'AcademicYearID', 'Academic Year', '', 'Based on the Selected Academic Year  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'CompletionDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'CompletionDescription', '', '', 'OGP_Enrolment.OverallCompletionID -> Completion.Description  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'StudentRef')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'StudentRef', 'Student Ref', '', 'OGP_Student.StudentRef  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Surname')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Surname', 'Surname', '', 'OGP_Student.Surname  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Forenames')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Forenames', 'Forenames', '', 'OGP_Student.Forenames  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'GroupCode')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'GroupCode', 'Group Code', '', 'OGP_Group.OGP_GroupCode  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'GroupTitle')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'GroupTitle', 'Group Title', '', 'OGP_Group.OGP_GroupTitle  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'CourseCode')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'CourseCode', 'Course Code', '', 'Course.CourseCode  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'CourseTitle')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'CourseTitle', 'Course Title', '', 'Course.Title  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'DepartmentName')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'DepartmentName', '[DEPT]', '', 'OGP_CollegeStructure.CollegeStructureName retrieved for each OGP_CollegeStructureGroup record  [sp_WebPlus_MarkBookStatsSummary_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'LearnAimGLH')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'LearnAimGLH', 'Learning Aim / GLH', '', 'Calculated for the Enrolments Learning Aim  [sp_WebPlus_MarkBookStatsSummary_Select]')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'CountEnrols')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'CountEnrols', 'No. Enrols', '', 'Calculated per [UNIT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
--
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl1_Allocated')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl1_Allocated', '[UNIT] Allocated', '', 'Calculated per [UNIT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl1_SumSizePerEnrol')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl1_SumSizePerEnrol', '[UNIT] Allocated Size per Enrol', '', 'Calculated per [UNIT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl1_Complete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl1_Complete', '[UNIT] Complete', 'The number of allocated [UNIT](s) with the Complete box ticked.', 'Calculated per [UNIT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl1_CompletePercent')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl1_CompletePercent', '[UNIT] %Complete', '', 'Calculated per [UNIT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl1_Late')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl1_Late', '[UNIT] Late', 'For [UNIT](s) that are not marked (where the Date Marked is blank), this is a count of where the Expected Date (plus Grace Period) is less than todays date.', 'Calculated per [UNIT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl1_MissingExpDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl1_MissingExpDate', '[UNIT] MissingExpDate', 'For [UNIT](s) that are not marked (where the Date Marked is blank), this is a count of blank Expected End Dates.', 'Calculated per [UNIT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl1_Due')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl1_Due', '[UNIT] Due', 'For [UNIT](s) that are not marked (where the Date Marked is blank), this is a count of [UNIT](s) expected between today and the selected Due Date.', 'Calculated per [UNIT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
--
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl2_Allocated')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl2_Allocated', '[ASSESSMENT] Allocated', '', 'Calculated per [ASSESSMENT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl2_Complete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl2_Complete', '[ASSESSMENT] Complete', 'The number of allocated [ASSESSMENT](s) with the Complete box ticked.', 'Calculated per [ASSESSMENT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl2_CompletePercent')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl2_CompletePercent', '[ASSESSMENT] %Complete', '', 'Calculated per [ASSESSMENT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl2_Late')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl2_Late', '[ASSESSMENT] Late', 'For [ASSESSMENT](s) that are not marked (where the Date Marked is blank), this is a count of where the Expected Date (plus Grace Period) is less than todays date.', 'Calculated per [ASSESSMENT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl2_MissingExpDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl2_MissingExpDate', '[ASSESSMENT] MissingExpDate', 'For [ASSESSMENT](s) that are not marked (where the Date Marked is blank), this is a count of blank Expected End Dates.', 'Calculated per [ASSESSMENT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl2_Due')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl2_Due', '[ASSESSMENT] Due', 'For [ASSESSMENT](s) that are not marked (where the Date Marked is blank), this is a count of [ASSESSMENT](s) expected between today and the selected Due Date.', 'Calculated per [ASSESSMENT] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
--
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl3_Allocated')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl3_Allocated', '[CRITERIA] Allocated', '', 'Calculated per [CRITERIA] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl3_Complete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl3_Complete', '[CRITERIA] Complete', 'The number of allocated [CRITERIA](s) with the Complete box ticked.', 'Calculated per [CRITERIA] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl3_CompletePercent')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl3_CompletePercent', '[CRITERIA] %Complete', '', 'Calculated per [CRITERIA] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl3_Late')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl3_Late', '[CRITERIA] Late', '', 'Calculated per [CRITERIA] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl3_MissingExpDate')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl3_MissingExpDate', '[CRITERIA] MissingExpDate', '', 'Calculated per [CRITERIA] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTATSSUMMARY' AND ColumnName = 'Lvl3_Due')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTATSSUMMARY', 'Lvl3_Due', '[CRITERIA] Due', '', 'Calculated per [CRITERIA] based on Group Enrolments  [sp_WebPlus_MarkBookStatsSummary_Select]')
END



--enrolment-element-students Grid
--DELETE FROM WebPlusTableColumn WHERE GridName = 'ENROLMENTELEMENTSTUDENTS' 

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'ENROLMENTELEMENTSTUDENTS' AND ColumnName = 'Completion')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('ENROLMENTELEMENTSTUDENTS', 'Completion', ' ', '', 'OGP_Enrolment.OverallCompletionID -> Completion.Description  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'ENROLMENTELEMENTSTUDENTS' AND ColumnName = 'StudentRef')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('ENROLMENTELEMENTSTUDENTS', 'StudentRef', 'Student Ref', '', 'OGP_Enrolment.StudentRef  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'ENROLMENTELEMENTSTUDENTS' AND ColumnName = 'Surname')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('ENROLMENTELEMENTSTUDENTS', 'Surname', 'Surname', '', 'OGP_Student.Surname  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'ENROLMENTELEMENTSTUDENTS' AND ColumnName = 'Forenames')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('ENROLMENTELEMENTSTUDENTS', 'Forenames', 'Forenames', '', 'OGP_Student.Forenames  [sp_WebPlus_MarkBookMaint_Select]')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'ENROLMENTELEMENTSTUDENTS' AND ColumnName = 'StudentDoesElement')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('ENROLMENTELEMENTSTUDENTS', 'StudentDoesElement', 'Student Does Element', '', '!OGP_EnrolmentElement.DoesNotDoElement  [sp_WebPlus_MarkBookMaint_Select]')
END



--Markbook Student Grid
--SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT'
--DELETE FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' 

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'ElementTypeID')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'ElementTypeID', 'Element Type', '', 'OGP_Element.OGP_ElementTypeID --> OGP_ElementType.Description  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'ElementCode')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'ElementCode', 'Code', '', 'OGP_Element.ElementCode  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'ElementDescription')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'ElementDescription', 'Description', '', 'OGP_Element.Description  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
--
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'OrderBy')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'OrderBy', 'Order', '', 'Based on OGP_Element.OrderBy  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
--
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'Complete')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'Complete', 'Complete', '', 'OGP_EnrolmentElement.Complete  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'Grade')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'Grade', 'Grade', '', 'OGP_EnrolmentElement.Grade  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END

IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'Size')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'Size', 'Size', '', 'OGP_Element.Size  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'Points')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'Points', 'Points', '', 'OGP_EnrolmentElement.Points  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'OutOfPoints')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'OutOfPoints', 'Out of', '', 'OGP_Element.OutOfPoints  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
--
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'DateSet')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'DateSet', 'Date Set', '', 'COALESCE(OGP_GroupElement.DateSet, OGP_EnrolmentElement.DateSet)  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'DateExpected')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'DateExpected', 'Date Expected', '', 'COALESCE(OGP_GroupElement.DateExpected, OGP_EnrolmentElement.DateExpected)  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'DateMarked')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'DateMarked', 'Date Marked', '', 'OGP_EnrolmentElement.DateMarked  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
--
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'NumResubmissions')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'NumResubmissions', 'No. Resubs', 'Number of Resubmissions', 'Calculated: Count(OGP_EnrolmentElementResubmission.ID)  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'Comment')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'Comment', 'Teacher Comment', '', 'OGP_EnrolmentElement.Comment  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
IF NOT EXISTS (SELECT * FROM WebPlusTableColumn WHERE GridName = 'MARKBOOKSTUDENT' AND ColumnName = 'FeedbackStudent')
BEGIN
    INSERT INTO WebPlusTableColumn (GridName, ColumnName, ColumnHeading, ColumnTitle, ColumnInfo)
    VALUES ('MARKBOOKSTUDENT', 'FeedbackStudent', 'Student Feedback', '', 'OGP_EnrolmentElement.FeedbackStudent  [sp_WebPlus_MarkBookMaint_Select] (STUDENTVIEW)')
END
